/*
*
* GoodsTemplateBeanExample.java
* @author may
* @date 2021-03-19 11:17:01
*/
package com.steel.yfmall.cloud.assistant.po.view;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class GoodsTemplateBeanExample {
    /**
     * zg_goods_template
     */
    protected String orderByClause;

    /**
     * zg_goods_template
     */
    protected boolean distinct;

    /**
     * zg_goods_template
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:zg_goods_template
     * @Title: GoodsTemplateBeanExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-03-19 11:17:01
     */
    public GoodsTemplateBeanExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:zg_goods_template
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-03-19 11:17:01
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:zg_goods_template
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-03-19 11:17:01
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:zg_goods_template
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-03-19 11:17:01
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:zg_goods_template
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-03-19 11:17:01
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:zg_goods_template
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-03-19 11:17:01
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:zg_goods_template
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-03-19 11:17:01
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:zg_goods_template
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-03-19 11:17:01
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:zg_goods_template
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-03-19 11:17:01
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:zg_goods_template
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-03-19 11:17:01
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:zg_goods_template
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-03-19 11:17:01
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title zg_goods_template表的实体类
     * @description zg_goods_template
     * @version 1.0
     * @author may
     * @date 2021-03-19 11:17:01
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNull() {
            addCriterion("brand_id is null");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNotNull() {
            addCriterion("brand_id is not null");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualTo(String value) {
            addCriterion("brand_id =", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualTo(String value) {
            addCriterion("brand_id <>", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThan(String value) {
            addCriterion("brand_id >", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualTo(String value) {
            addCriterion("brand_id >=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThan(String value) {
            addCriterion("brand_id <", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualTo(String value) {
            addCriterion("brand_id <=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLike(String value) {
            addCriterion("brand_id like", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotLike(String value) {
            addCriterion("brand_id not like", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdIn(List<String> values) {
            addCriterion("brand_id in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotIn(List<String> values) {
            addCriterion("brand_id not in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdBetween(String value1, String value2) {
            addCriterion("brand_id between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotBetween(String value1, String value2) {
            addCriterion("brand_id not between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andProdClassIsNull() {
            addCriterion("prod_class is null");
            return (Criteria) this;
        }

        public Criteria andProdClassIsNotNull() {
            addCriterion("prod_class is not null");
            return (Criteria) this;
        }

        public Criteria andProdClassEqualTo(String value) {
            addCriterion("prod_class =", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassNotEqualTo(String value) {
            addCriterion("prod_class <>", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassGreaterThan(String value) {
            addCriterion("prod_class >", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassGreaterThanOrEqualTo(String value) {
            addCriterion("prod_class >=", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassLessThan(String value) {
            addCriterion("prod_class <", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassLessThanOrEqualTo(String value) {
            addCriterion("prod_class <=", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassLike(String value) {
            addCriterion("prod_class like", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassNotLike(String value) {
            addCriterion("prod_class not like", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassIn(List<String> values) {
            addCriterion("prod_class in", values, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassNotIn(List<String> values) {
            addCriterion("prod_class not in", values, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassBetween(String value1, String value2) {
            addCriterion("prod_class between", value1, value2, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassNotBetween(String value1, String value2) {
            addCriterion("prod_class not between", value1, value2, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoIsNull() {
            addCriterion("prod_type_no is null");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoIsNotNull() {
            addCriterion("prod_type_no is not null");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoEqualTo(String value) {
            addCriterion("prod_type_no =", value, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoNotEqualTo(String value) {
            addCriterion("prod_type_no <>", value, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoGreaterThan(String value) {
            addCriterion("prod_type_no >", value, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoGreaterThanOrEqualTo(String value) {
            addCriterion("prod_type_no >=", value, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoLessThan(String value) {
            addCriterion("prod_type_no <", value, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoLessThanOrEqualTo(String value) {
            addCriterion("prod_type_no <=", value, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoLike(String value) {
            addCriterion("prod_type_no like", value, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoNotLike(String value) {
            addCriterion("prod_type_no not like", value, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoIn(List<String> values) {
            addCriterion("prod_type_no in", values, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoNotIn(List<String> values) {
            addCriterion("prod_type_no not in", values, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoBetween(String value1, String value2) {
            addCriterion("prod_type_no between", value1, value2, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeNoNotBetween(String value1, String value2) {
            addCriterion("prod_type_no not between", value1, value2, "prodTypeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNull() {
            addCriterion("trade_no is null");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNotNull() {
            addCriterion("trade_no is not null");
            return (Criteria) this;
        }

        public Criteria andTradeNoEqualTo(String value) {
            addCriterion("trade_no =", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotEqualTo(String value) {
            addCriterion("trade_no <>", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThan(String value) {
            addCriterion("trade_no >", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThanOrEqualTo(String value) {
            addCriterion("trade_no >=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThan(String value) {
            addCriterion("trade_no <", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThanOrEqualTo(String value) {
            addCriterion("trade_no <=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLike(String value) {
            addCriterion("trade_no like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotLike(String value) {
            addCriterion("trade_no not like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoIn(List<String> values) {
            addCriterion("trade_no in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotIn(List<String> values) {
            addCriterion("trade_no not in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoBetween(String value1, String value2) {
            addCriterion("trade_no between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotBetween(String value1, String value2) {
            addCriterion("trade_no not between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andStockIdIsNull() {
            addCriterion("stock_id is null");
            return (Criteria) this;
        }

        public Criteria andStockIdIsNotNull() {
            addCriterion("stock_id is not null");
            return (Criteria) this;
        }

        public Criteria andStockIdEqualTo(String value) {
            addCriterion("stock_id =", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotEqualTo(String value) {
            addCriterion("stock_id <>", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdGreaterThan(String value) {
            addCriterion("stock_id >", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdGreaterThanOrEqualTo(String value) {
            addCriterion("stock_id >=", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdLessThan(String value) {
            addCriterion("stock_id <", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdLessThanOrEqualTo(String value) {
            addCriterion("stock_id <=", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdLike(String value) {
            addCriterion("stock_id like", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotLike(String value) {
            addCriterion("stock_id not like", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdIn(List<String> values) {
            addCriterion("stock_id in", values, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotIn(List<String> values) {
            addCriterion("stock_id not in", values, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdBetween(String value1, String value2) {
            addCriterion("stock_id between", value1, value2, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotBetween(String value1, String value2) {
            addCriterion("stock_id not between", value1, value2, "stockId");
            return (Criteria) this;
        }

        public Criteria andProdThickIsNull() {
            addCriterion("prod_thick is null");
            return (Criteria) this;
        }

        public Criteria andProdThickIsNotNull() {
            addCriterion("prod_thick is not null");
            return (Criteria) this;
        }

        public Criteria andProdThickEqualTo(BigDecimal value) {
            addCriterion("prod_thick =", value, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickNotEqualTo(BigDecimal value) {
            addCriterion("prod_thick <>", value, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickGreaterThan(BigDecimal value) {
            addCriterion("prod_thick >", value, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_thick >=", value, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickLessThan(BigDecimal value) {
            addCriterion("prod_thick <", value, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickLessThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_thick <=", value, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickIn(List<BigDecimal> values) {
            addCriterion("prod_thick in", values, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickNotIn(List<BigDecimal> values) {
            addCriterion("prod_thick not in", values, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_thick between", value1, value2, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdThickNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_thick not between", value1, value2, "prodThick");
            return (Criteria) this;
        }

        public Criteria andProdWidthIsNull() {
            addCriterion("prod_width is null");
            return (Criteria) this;
        }

        public Criteria andProdWidthIsNotNull() {
            addCriterion("prod_width is not null");
            return (Criteria) this;
        }

        public Criteria andProdWidthEqualTo(BigDecimal value) {
            addCriterion("prod_width =", value, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthNotEqualTo(BigDecimal value) {
            addCriterion("prod_width <>", value, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthGreaterThan(BigDecimal value) {
            addCriterion("prod_width >", value, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_width >=", value, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthLessThan(BigDecimal value) {
            addCriterion("prod_width <", value, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_width <=", value, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthIn(List<BigDecimal> values) {
            addCriterion("prod_width in", values, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthNotIn(List<BigDecimal> values) {
            addCriterion("prod_width not in", values, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_width between", value1, value2, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdWidthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_width not between", value1, value2, "prodWidth");
            return (Criteria) this;
        }

        public Criteria andProdLenIsNull() {
            addCriterion("prod_len is null");
            return (Criteria) this;
        }

        public Criteria andProdLenIsNotNull() {
            addCriterion("prod_len is not null");
            return (Criteria) this;
        }

        public Criteria andProdLenEqualTo(BigDecimal value) {
            addCriterion("prod_len =", value, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenNotEqualTo(BigDecimal value) {
            addCriterion("prod_len <>", value, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenGreaterThan(BigDecimal value) {
            addCriterion("prod_len >", value, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_len >=", value, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenLessThan(BigDecimal value) {
            addCriterion("prod_len <", value, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenLessThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_len <=", value, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenIn(List<BigDecimal> values) {
            addCriterion("prod_len in", values, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenNotIn(List<BigDecimal> values) {
            addCriterion("prod_len not in", values, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_len between", value1, value2, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdLenNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_len not between", value1, value2, "prodLen");
            return (Criteria) this;
        }

        public Criteria andProdWgtIsNull() {
            addCriterion("prod_wgt is null");
            return (Criteria) this;
        }

        public Criteria andProdWgtIsNotNull() {
            addCriterion("prod_wgt is not null");
            return (Criteria) this;
        }

        public Criteria andProdWgtEqualTo(BigDecimal value) {
            addCriterion("prod_wgt =", value, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtNotEqualTo(BigDecimal value) {
            addCriterion("prod_wgt <>", value, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtGreaterThan(BigDecimal value) {
            addCriterion("prod_wgt >", value, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_wgt >=", value, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtLessThan(BigDecimal value) {
            addCriterion("prod_wgt <", value, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_wgt <=", value, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtIn(List<BigDecimal> values) {
            addCriterion("prod_wgt in", values, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtNotIn(List<BigDecimal> values) {
            addCriterion("prod_wgt not in", values, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_wgt between", value1, value2, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andProdWgtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_wgt not between", value1, value2, "prodWgt");
            return (Criteria) this;
        }

        public Criteria andSizeMsgIsNull() {
            addCriterion("size_msg is null");
            return (Criteria) this;
        }

        public Criteria andSizeMsgIsNotNull() {
            addCriterion("size_msg is not null");
            return (Criteria) this;
        }

        public Criteria andSizeMsgEqualTo(String value) {
            addCriterion("size_msg =", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgNotEqualTo(String value) {
            addCriterion("size_msg <>", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgGreaterThan(String value) {
            addCriterion("size_msg >", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgGreaterThanOrEqualTo(String value) {
            addCriterion("size_msg >=", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgLessThan(String value) {
            addCriterion("size_msg <", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgLessThanOrEqualTo(String value) {
            addCriterion("size_msg <=", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgLike(String value) {
            addCriterion("size_msg like", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgNotLike(String value) {
            addCriterion("size_msg not like", value, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgIn(List<String> values) {
            addCriterion("size_msg in", values, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgNotIn(List<String> values) {
            addCriterion("size_msg not in", values, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgBetween(String value1, String value2) {
            addCriterion("size_msg between", value1, value2, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andSizeMsgNotBetween(String value1, String value2) {
            addCriterion("size_msg not between", value1, value2, "sizeMsg");
            return (Criteria) this;
        }

        public Criteria andGradeIsNull() {
            addCriterion("grade is null");
            return (Criteria) this;
        }

        public Criteria andGradeIsNotNull() {
            addCriterion("grade is not null");
            return (Criteria) this;
        }

        public Criteria andGradeEqualTo(String value) {
            addCriterion("grade =", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotEqualTo(String value) {
            addCriterion("grade <>", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeGreaterThan(String value) {
            addCriterion("grade >", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeGreaterThanOrEqualTo(String value) {
            addCriterion("grade >=", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLessThan(String value) {
            addCriterion("grade <", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLessThanOrEqualTo(String value) {
            addCriterion("grade <=", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLike(String value) {
            addCriterion("grade like", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotLike(String value) {
            addCriterion("grade not like", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeIn(List<String> values) {
            addCriterion("grade in", values, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotIn(List<String> values) {
            addCriterion("grade not in", values, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeBetween(String value1, String value2) {
            addCriterion("grade between", value1, value2, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotBetween(String value1, String value2) {
            addCriterion("grade not between", value1, value2, "grade");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIsNull() {
            addCriterion("count_wgt_mode is null");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIsNotNull() {
            addCriterion("count_wgt_mode is not null");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeEqualTo(String value) {
            addCriterion("count_wgt_mode =", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotEqualTo(String value) {
            addCriterion("count_wgt_mode <>", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeGreaterThan(String value) {
            addCriterion("count_wgt_mode >", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeGreaterThanOrEqualTo(String value) {
            addCriterion("count_wgt_mode >=", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLessThan(String value) {
            addCriterion("count_wgt_mode <", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLessThanOrEqualTo(String value) {
            addCriterion("count_wgt_mode <=", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLike(String value) {
            addCriterion("count_wgt_mode like", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotLike(String value) {
            addCriterion("count_wgt_mode not like", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIn(List<String> values) {
            addCriterion("count_wgt_mode in", values, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotIn(List<String> values) {
            addCriterion("count_wgt_mode not in", values, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeBetween(String value1, String value2) {
            addCriterion("count_wgt_mode between", value1, value2, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotBetween(String value1, String value2) {
            addCriterion("count_wgt_mode not between", value1, value2, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andSizePiecesIsNull() {
            addCriterion("size_pieces is null");
            return (Criteria) this;
        }

        public Criteria andSizePiecesIsNotNull() {
            addCriterion("size_pieces is not null");
            return (Criteria) this;
        }

        public Criteria andSizePiecesEqualTo(Integer value) {
            addCriterion("size_pieces =", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesNotEqualTo(Integer value) {
            addCriterion("size_pieces <>", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesGreaterThan(Integer value) {
            addCriterion("size_pieces >", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesGreaterThanOrEqualTo(Integer value) {
            addCriterion("size_pieces >=", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesLessThan(Integer value) {
            addCriterion("size_pieces <", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesLessThanOrEqualTo(Integer value) {
            addCriterion("size_pieces <=", value, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesIn(List<Integer> values) {
            addCriterion("size_pieces in", values, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesNotIn(List<Integer> values) {
            addCriterion("size_pieces not in", values, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesBetween(Integer value1, Integer value2) {
            addCriterion("size_pieces between", value1, value2, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andSizePiecesNotBetween(Integer value1, Integer value2) {
            addCriterion("size_pieces not between", value1, value2, "sizePieces");
            return (Criteria) this;
        }

        public Criteria andCraftIsNull() {
            addCriterion("craft is null");
            return (Criteria) this;
        }

        public Criteria andCraftIsNotNull() {
            addCriterion("craft is not null");
            return (Criteria) this;
        }

        public Criteria andCraftEqualTo(Integer value) {
            addCriterion("craft =", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftNotEqualTo(Integer value) {
            addCriterion("craft <>", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftGreaterThan(Integer value) {
            addCriterion("craft >", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftGreaterThanOrEqualTo(Integer value) {
            addCriterion("craft >=", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftLessThan(Integer value) {
            addCriterion("craft <", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftLessThanOrEqualTo(Integer value) {
            addCriterion("craft <=", value, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftIn(List<Integer> values) {
            addCriterion("craft in", values, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftNotIn(List<Integer> values) {
            addCriterion("craft not in", values, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftBetween(Integer value1, Integer value2) {
            addCriterion("craft between", value1, value2, "craft");
            return (Criteria) this;
        }

        public Criteria andCraftNotBetween(Integer value1, Integer value2) {
            addCriterion("craft not between", value1, value2, "craft");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeIsNull() {
            addCriterion("is_downgrade is null");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeIsNotNull() {
            addCriterion("is_downgrade is not null");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeEqualTo(String value) {
            addCriterion("is_downgrade =", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeNotEqualTo(String value) {
            addCriterion("is_downgrade <>", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeGreaterThan(String value) {
            addCriterion("is_downgrade >", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeGreaterThanOrEqualTo(String value) {
            addCriterion("is_downgrade >=", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeLessThan(String value) {
            addCriterion("is_downgrade <", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeLessThanOrEqualTo(String value) {
            addCriterion("is_downgrade <=", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeLike(String value) {
            addCriterion("is_downgrade like", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeNotLike(String value) {
            addCriterion("is_downgrade not like", value, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeIn(List<String> values) {
            addCriterion("is_downgrade in", values, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeNotIn(List<String> values) {
            addCriterion("is_downgrade not in", values, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeBetween(String value1, String value2) {
            addCriterion("is_downgrade between", value1, value2, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andIsDowngradeNotBetween(String value1, String value2) {
            addCriterion("is_downgrade not between", value1, value2, "isDowngrade");
            return (Criteria) this;
        }

        public Criteria andProdQtyIsNull() {
            addCriterion("prod_qty is null");
            return (Criteria) this;
        }

        public Criteria andProdQtyIsNotNull() {
            addCriterion("prod_qty is not null");
            return (Criteria) this;
        }

        public Criteria andProdQtyEqualTo(BigDecimal value) {
            addCriterion("prod_qty =", value, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyNotEqualTo(BigDecimal value) {
            addCriterion("prod_qty <>", value, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyGreaterThan(BigDecimal value) {
            addCriterion("prod_qty >", value, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_qty >=", value, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyLessThan(BigDecimal value) {
            addCriterion("prod_qty <", value, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("prod_qty <=", value, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyIn(List<BigDecimal> values) {
            addCriterion("prod_qty in", values, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyNotIn(List<BigDecimal> values) {
            addCriterion("prod_qty not in", values, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_qty between", value1, value2, "prodQty");
            return (Criteria) this;
        }

        public Criteria andProdQtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("prod_qty not between", value1, value2, "prodQty");
            return (Criteria) this;
        }

        public Criteria andStandNameIsNull() {
            addCriterion("stand_name is null");
            return (Criteria) this;
        }

        public Criteria andStandNameIsNotNull() {
            addCriterion("stand_name is not null");
            return (Criteria) this;
        }

        public Criteria andStandNameEqualTo(String value) {
            addCriterion("stand_name =", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotEqualTo(String value) {
            addCriterion("stand_name <>", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameGreaterThan(String value) {
            addCriterion("stand_name >", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameGreaterThanOrEqualTo(String value) {
            addCriterion("stand_name >=", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLessThan(String value) {
            addCriterion("stand_name <", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLessThanOrEqualTo(String value) {
            addCriterion("stand_name <=", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLike(String value) {
            addCriterion("stand_name like", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotLike(String value) {
            addCriterion("stand_name not like", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameIn(List<String> values) {
            addCriterion("stand_name in", values, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotIn(List<String> values) {
            addCriterion("stand_name not in", values, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameBetween(String value1, String value2) {
            addCriterion("stand_name between", value1, value2, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotBetween(String value1, String value2) {
            addCriterion("stand_name not between", value1, value2, "standName");
            return (Criteria) this;
        }

        public Criteria andPsrNoIsNull() {
            addCriterion("psr_no is null");
            return (Criteria) this;
        }

        public Criteria andPsrNoIsNotNull() {
            addCriterion("psr_no is not null");
            return (Criteria) this;
        }

        public Criteria andPsrNoEqualTo(String value) {
            addCriterion("psr_no =", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotEqualTo(String value) {
            addCriterion("psr_no <>", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoGreaterThan(String value) {
            addCriterion("psr_no >", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoGreaterThanOrEqualTo(String value) {
            addCriterion("psr_no >=", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLessThan(String value) {
            addCriterion("psr_no <", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLessThanOrEqualTo(String value) {
            addCriterion("psr_no <=", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLike(String value) {
            addCriterion("psr_no like", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotLike(String value) {
            addCriterion("psr_no not like", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoIn(List<String> values) {
            addCriterion("psr_no in", values, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotIn(List<String> values) {
            addCriterion("psr_no not in", values, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoBetween(String value1, String value2) {
            addCriterion("psr_no between", value1, value2, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotBetween(String value1, String value2) {
            addCriterion("psr_no not between", value1, value2, "psrNo");
            return (Criteria) this;
        }

        public Criteria andColorIsNull() {
            addCriterion("color is null");
            return (Criteria) this;
        }

        public Criteria andColorIsNotNull() {
            addCriterion("color is not null");
            return (Criteria) this;
        }

        public Criteria andColorEqualTo(String value) {
            addCriterion("color =", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotEqualTo(String value) {
            addCriterion("color <>", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorGreaterThan(String value) {
            addCriterion("color >", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorGreaterThanOrEqualTo(String value) {
            addCriterion("color >=", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLessThan(String value) {
            addCriterion("color <", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLessThanOrEqualTo(String value) {
            addCriterion("color <=", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLike(String value) {
            addCriterion("color like", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotLike(String value) {
            addCriterion("color not like", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorIn(List<String> values) {
            addCriterion("color in", values, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotIn(List<String> values) {
            addCriterion("color not in", values, "color");
            return (Criteria) this;
        }

        public Criteria andColorBetween(String value1, String value2) {
            addCriterion("color between", value1, value2, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotBetween(String value1, String value2) {
            addCriterion("color not between", value1, value2, "color");
            return (Criteria) this;
        }

        public Criteria andApnnoIsNull() {
            addCriterion("apnNo is null");
            return (Criteria) this;
        }

        public Criteria andApnnoIsNotNull() {
            addCriterion("apnNo is not null");
            return (Criteria) this;
        }

        public Criteria andApnnoEqualTo(String value) {
            addCriterion("apnNo =", value, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoNotEqualTo(String value) {
            addCriterion("apnNo <>", value, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoGreaterThan(String value) {
            addCriterion("apnNo >", value, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoGreaterThanOrEqualTo(String value) {
            addCriterion("apnNo >=", value, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoLessThan(String value) {
            addCriterion("apnNo <", value, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoLessThanOrEqualTo(String value) {
            addCriterion("apnNo <=", value, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoLike(String value) {
            addCriterion("apnNo like", value, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoNotLike(String value) {
            addCriterion("apnNo not like", value, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoIn(List<String> values) {
            addCriterion("apnNo in", values, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoNotIn(List<String> values) {
            addCriterion("apnNo not in", values, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoBetween(String value1, String value2) {
            addCriterion("apnNo between", value1, value2, "apnno");
            return (Criteria) this;
        }

        public Criteria andApnnoNotBetween(String value1, String value2) {
            addCriterion("apnNo not between", value1, value2, "apnno");
            return (Criteria) this;
        }

        public Criteria andGoodsSnIsNull() {
            addCriterion("goods_sn is null");
            return (Criteria) this;
        }

        public Criteria andGoodsSnIsNotNull() {
            addCriterion("goods_sn is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsSnEqualTo(String value) {
            addCriterion("goods_sn =", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnNotEqualTo(String value) {
            addCriterion("goods_sn <>", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnGreaterThan(String value) {
            addCriterion("goods_sn >", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnGreaterThanOrEqualTo(String value) {
            addCriterion("goods_sn >=", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnLessThan(String value) {
            addCriterion("goods_sn <", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnLessThanOrEqualTo(String value) {
            addCriterion("goods_sn <=", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnLike(String value) {
            addCriterion("goods_sn like", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnNotLike(String value) {
            addCriterion("goods_sn not like", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnIn(List<String> values) {
            addCriterion("goods_sn in", values, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnNotIn(List<String> values) {
            addCriterion("goods_sn not in", values, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnBetween(String value1, String value2) {
            addCriterion("goods_sn between", value1, value2, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnNotBetween(String value1, String value2) {
            addCriterion("goods_sn not between", value1, value2, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionIsNull() {
            addCriterion("attr_encryption is null");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionIsNotNull() {
            addCriterion("attr_encryption is not null");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionEqualTo(String value) {
            addCriterion("attr_encryption =", value, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionNotEqualTo(String value) {
            addCriterion("attr_encryption <>", value, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionGreaterThan(String value) {
            addCriterion("attr_encryption >", value, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionGreaterThanOrEqualTo(String value) {
            addCriterion("attr_encryption >=", value, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionLessThan(String value) {
            addCriterion("attr_encryption <", value, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionLessThanOrEqualTo(String value) {
            addCriterion("attr_encryption <=", value, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionLike(String value) {
            addCriterion("attr_encryption like", value, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionNotLike(String value) {
            addCriterion("attr_encryption not like", value, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionIn(List<String> values) {
            addCriterion("attr_encryption in", values, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionNotIn(List<String> values) {
            addCriterion("attr_encryption not in", values, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionBetween(String value1, String value2) {
            addCriterion("attr_encryption between", value1, value2, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andAttrEncryptionNotBetween(String value1, String value2) {
            addCriterion("attr_encryption not between", value1, value2, "attrEncryption");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andVersionIntIsNull() {
            addCriterion("version_int is null");
            return (Criteria) this;
        }

        public Criteria andVersionIntIsNotNull() {
            addCriterion("version_int is not null");
            return (Criteria) this;
        }

        public Criteria andVersionIntEqualTo(Integer value) {
            addCriterion("version_int =", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotEqualTo(Integer value) {
            addCriterion("version_int <>", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntGreaterThan(Integer value) {
            addCriterion("version_int >", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntGreaterThanOrEqualTo(Integer value) {
            addCriterion("version_int >=", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntLessThan(Integer value) {
            addCriterion("version_int <", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntLessThanOrEqualTo(Integer value) {
            addCriterion("version_int <=", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntIn(List<Integer> values) {
            addCriterion("version_int in", values, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotIn(List<Integer> values) {
            addCriterion("version_int not in", values, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntBetween(Integer value1, Integer value2) {
            addCriterion("version_int between", value1, value2, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotBetween(Integer value1, Integer value2) {
            addCriterion("version_int not between", value1, value2, "versionInt");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    /**
     * zg_goods_template
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title zg_goods_template表的实体类
     * @description zg_goods_template
     * @version 1.0
     * @author may
     * @date 2021-03-19 11:17:01
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
